Excel Magic Trick 301: 1900 Date Problems And Fixes

Excel Magic Trick 301: 1900 Date Problems and Fixes

Excel Magic Trick 300: YEAR DATE TEXT functions for Date Label

Show Blank Instead of 101900 in Excel | Don't Show 1900 on Blank Date | Leave Blank If No Date

Chester Tugwell

Excel Magic Trick #141 part 1: Day Numbers to Dates

Excel Magic Trick 1390: Average Number of Days Between Dates in a Single Column 3 Examples

Excel tip to Fix unrecognized date issue | Useful MS Excel Hacks and Tricks | Date format change

Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864

Excel Magic Trick 310: D Functions & Date Criteria

Excel Magic Trick 312: Extract Date & Time From Text String

Excel Magic Trick 428: Trouble Entering Dates - Date Syntax

Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbers

Excel Magic Trick # 281: Formula For Vest Date

Can Excel Handle Dates Before 1900 (Yes!) | Difference in Years, Month or Days

Chester Tugwell

Value error for DATEVALUE function in Excel

Excel Magic Trick 257 Convert Dates as Text to Dates As No.

Excel Magic Trick 942: Lookup Last Shipment Date For Customer, Sorted & Not Sorted Date Column

Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00")

Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes.

Excel Magic Trick 1080: Age From Alphanumeric Text String, Has Incomplete Date Year = 20?? or 19??

Fixing date format problems in Excel data - using PrepYourData